import pandas as pd
data = pd.read_excel('F:\\python\\第7章\\销售表.xlsx', sheet_name=0)
a = data.groupby(by='产品名称')
for name, group in a:
    print(name)
    print(group)
b = a.get_group('转速表')
print(b)
